1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Controllers
12 {
13 class Kho_KiemKhoCtrl
14 {
15
16 //them moi
17 public static int InsertKho_KiemKho(int _IdKho_KiemKho, string _TrangThai, float _TongSoMatHangTrongKho, float _TongSoMatHangKiemKho, string _DienGiai, DateTime _NgayKiemKho)
18 {
19 try
20 {
21 Models.Kho_KiemKhoMod kho = new Models.Kho_KiemKhoMod(_IdKho_KiemKho, _TrangThai, _TongSoMatHangTrongKho, _TongSoMatHangKiemKho, _DienGiai, _NgayKiemKho);
22 return kho.InsertKho_KiemKho();
23 }
24 catch
25 {
26 return 0;
27 }
28 }
29
30 //update
31 public static int UpdateKho_KiemKho(int _IdKho_KiemKho, string _TrangThai, float _TongSoMatHangTrongKho, float _TongSoMatHangKiemKho, string _DienGiai, DateTime _NgayKiemKho)
32 {
33 try
34 {
35 Models.Kho_KiemKhoMod kho = new Models.Kho_KiemKhoMod(_IdKho_KiemKho, _TrangThai, _TongSoMatHangTrongKho, _TongSoMatHangKiemKho, _DienGiai, _NgayKiemKho);
36 return kho.UpdateKho_KiemKho();
37 }
38 catch
39 {
40 return 0;
41 }
42 }
43 //xoa
44 public static int DeleteKho_KiemKho(int _IdKho_KiemKho)
45 {
46 try
47 {
48 Models.Kho_KiemKhoMod kho = new Models.Kho_KiemKhoMod(_IdKho_KiemKho);
49 return kho.DeleteKho_KiemKho();
50 }
51 catch
52 {
53 return 0;
54 }
55 }
56
57 //danh sach
58 public static DataSet FillDataSet_getKho_KiemKho_Search(int _IdKho_KiemKho, string _TrangThai, float _TongSoMatHangTrongKho, float _TongSoMatHangKiemKho, string _DienGiai, DateTime _NgayKiemKho, int _PageSize, int _PageIndex)
59 {
60 try
61 {
62 Models.Kho_KiemKhoMod kho = new Models.Kho_KiemKhoMod(_IdKho_KiemKho, _TrangThai, _TongSoMatHangTrongKho, _TongSoMatHangKiemKho, _DienGiai, _NgayKiemKho, _PageSize, _PageIndex);
63 return kho.FillDataSet_getKho_KiemKho_Search();
64 }
65 catch
66 {
67 return null;
68 }
69 }
70
71 //lay theo idkiemkho
72
73 public static DataSet FillDataSet_getKho_KiemKho_Get_ByIdKiemKho(int _IdKho_KiemKho)
74 {
75 try
76 {
77 Models.Kho_KiemKhoMod kho = new Models.Kho_KiemKhoMod(_IdKho_KiemKho);
78 return kho.FillDataSet_getKho_KiemKho_Get_ByIdKiemKho();
79 }
80 catch
81 {
82 return null;
83 }
84 }
85 }
86 }